const mysql  = require('mysql2/promise');
const {connection} = require('./common');

async function getCity(){
    let sql = 'select * from city'
    let res = await connection.execute(sql);
    let arr = res[0];
    return JSON.stringify(arr);
}

module.exports = {
    getCity
}